
[dbo].[BAEUpdateBatchInformation]
create procedure [dbo].[BAEUpdateBatchInformation] @orderNum float,
@taxDifferenceAmount MONEY as
DECLARE @batchNum VARCHAR(16)
SELECT @batchNum = BATCH_NUM
FROM Orders
WHERE ORDER_NUMBER = @orderNum;
UPDATE Batch
SET CONTROL_CASH = ( CONTROL_CASH + @taxDifferenceAmount ),
TRANS_CASH = ( TRANS_CASH + @taxDifferenceAmount)
WHERE BATCH_NUM = @batchNum;
GO